Labels:text | screenshot | font | paper | number | letter | document OCR: The following statement creates a table and provides STORAGE parameter values: CREATE TABLE dept (deptno NUMBER ( 2); VARCHAR2(14), VARCHAR2(13) ) STORAGE (INITIAL 100K NEXT50K WINEXTENTS 1 MAXEXTENTS 50 PCTINCREASE 5 ) Oracle7 allocates space for the table based on the STORAGE parameter values for the following reasons: Because the MINEXTENTS value is 1, Oracle7 allocates 1 extent for the cable upon creation .. Because the INITIAL value is 100KB, the first extent's size is 100KB. If the table data grows to exceed the first extent, Oracle7 allocates a second extent. Because the NEXT value is SOKB, the second extent's size is 50KB. If the table data subsequently grows to exceed the first two extents, Oracle7 allocates a third extent. Because the PCTINCREASE value is 5, the calculated size of the third extent is 5 percent larger than the second extent, or 52.5KB. If the data block size is 2KB, Oracle7 rounds this value to 52KB. If the table data continues to grow, Oracle7 allocates more extents, cach 5 percent larger than the previous one!" Because the MAXEXTENTS value is 50, Oracle7 can allocate as many as 50 extents for the table, Figure 3: STORAGE clause parameters and their effect on extent allocation. (Copyright @ 1994, Oracle Corporation.)
